create database Blogs
go
use Blogs
go
create table Users
(
Id int primary key identity,
Username nvarchar(6) not null,
Password nvarchar(80) not null 
)
create table Articles
(
Id int primary key identity,
Title nvarchar(10) not null,
Author nvarchar(10) not null,
CreatedTime datetime default getdate()
)
insert into Users(Username,Password)values('amdin','010927')
insert into Articles(Title,Author)values('战争与和平','列夫.托尔斯泰'),('巴黎圣母院','雨果'),('童年','高尔基'),('呼啸山庄','艾米丽.勃朗特')

select * from Users
select * from Articles